/*
 Navicat Premium Data Transfer

 Source Server         : 39.103.179.245 kuboluo
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : erp

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 24/12/2022 18:22:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for erp_goods
-- ----------------------------
DROP TABLE IF EXISTS `erp_goods`;
CREATE TABLE `erp_goods` (
  `id` varchar(36) NOT NULL,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
  `goods_sn` varchar(32) DEFAULT NULL COMMENT '商品SN',
  `goods_name` varchar(30) DEFAULT NULL COMMENT '商品名称',
  `spec` varchar(32) DEFAULT NULL COMMENT '规格',
  `goods_number` int(11) DEFAULT NULL COMMENT '库存数',
  `category_name` varchar(32) DEFAULT NULL COMMENT '产品分类',
  `buying_price` decimal(11,2) DEFAULT NULL COMMENT '进货价',
  `selling_price` decimal(11,2) DEFAULT NULL COMMENT '售货价',
  `selling_discount` int(11) DEFAULT NULL COMMENT '售价折扣',
  `warn_number` int(11) DEFAULT NULL COMMENT '库存报警数',
  `provider_name` varchar(32) DEFAULT NULL COMMENT '供货人名称',
  `goods_img` varchar(255) DEFAULT NULL COMMENT '商品图',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of erp_goods
-- ----------------------------
BEGIN;
INSERT INTO `erp_goods` VALUES ('1598529191949656072', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:32:54', 'A01', '1001', '柔软华', '大', 0, '食用菌', 322.00, 322.00, 100, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656080', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1002', '柔软华', '小', 0, '食用菌', 161.00, 161.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656088', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1003', '释怀', '大', 0, '食用菌', 364.00, 364.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656096', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1004', '释怀', '小', 0, '食用菌', 182.00, 182.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656104', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1005', '心本然', '大', 0, '食用菌', 350.00, 350.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656112', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1006', '心本然', '小', 0, '食用菌', 175.00, 175.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656120', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1007', '一卫安', '大', 0, '食用菌', 326.60, 326.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656128', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1008', '一卫安', '小', 0, '食用菌', 163.30, 163.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656136', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1009', '徒然草', '大', 0, '食用菌', 396.60, 396.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656144', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1010', '徒然草', '小', 0, '食用菌', 198.30, 198.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656152', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1011', '如韵', '大', 0, '食用菌', 373.30, 373.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656160', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1012', '如韵', '小', 0, '食用菌', 186.60, 186.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656168', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1013', '如响', '大', 0, '食用菌', 396.60, 396.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656176', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1014', '如响', '小', 0, '食用菌', 198.30, 198.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656184', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1015', '如阳', '大', 0, '食用菌', 373.30, 373.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656192', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1016', '如阳', '小', 0, '食用菌', 186.60, 186.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656200', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1017', '如本', '大', 0, '食用菌', 364.00, 364.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656208', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1018', '如本', '小', 0, '食用菌', 182.00, 182.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656216', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1019', '经古强', '大', 0, '食用菌', 364.00, 364.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656224', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1020', '经古强', '小', 0, '食用菌', 182.00, 182.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656232', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1021', '木之森', '大', 0, '食用菌', 465.30, 465.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656240', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1022', '木之森', '小', 0, '食用菌', 232.60, 232.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656248', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1023', '春相续', '大', 0, '食用菌', 326.60, 326.60, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656256', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1024', '春相续', '小', 0, '食用菌', 163.30, 163.30, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656264', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '1025', '童祯', '大', 0, '食用菌', 350.00, 350.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656272', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '1026', '童祯', '小', 0, '食用菌', 175.00, 175.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656273', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1027', '衣缓', '大', 0, '食用菌', 426.00, 426.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656274', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1028', '衣缓', '小', 0, '食用菌', 213.00, 213.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656279', 'admin', '2022-12-02 12:07:13', 'admin', '2022-12-17 20:22:44', 'A01', '1000', '玉鹤馨泉茶', NULL, 0, '食用菌', 300.00, 300.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656287', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3001', '丝柔洗涤液抑菌配方', '1L装', 0, '神马商城', 48.00, 20.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656295', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3002', '丝柔洗涤液机洗配方', '瓶装', 0, '神马商城', 48.00, 20.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656302', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3003', '雅姿植物光感牙膏', NULL, 0, '神马商城', 36.00, 15.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191949656309', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3004', '雅姿中药精华牙膏', NULL, 0, '神马商城', 24.00, 12.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191953850372', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3005', '雅姿KGF生物牙膏', NULL, 0, '神马商城', 36.00, 15.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191953850379', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3006', '抑菌泡沫洗手液', NULL, 0, '神马商城', 28.00, 15.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191953850386', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3007', '花容道茯纯霜', NULL, 0, '神马商城', 68.00, 25.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191953850393', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3008', '科美高浓缩洗洁精', NULL, 0, '神马商城', 48.00, 18.00, NULL, 5, NULL, NULL);
INSERT INTO `erp_goods` VALUES ('1598529191953850400', 'admin', '2022-12-02 12:07:13', NULL, NULL, 'A01', '3009', '丝柔洗涤液手洗配方', NULL, 0, '神马商城', 48.00, 18.00, NULL, 5, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for erp_order
-- ----------------------------
DROP TABLE IF EXISTS `erp_order`;
CREATE TABLE `erp_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
  `order_sn` varchar(32) DEFAULT NULL COMMENT '单据编码',
  `amount` decimal(10,2) DEFAULT '0.00' COMMENT '总金额',
  `goods_cnt` int(11) DEFAULT '0' COMMENT '商品数量',
  `order_type` varchar(32) DEFAULT NULL COMMENT '订单类型',
  `name` varchar(20) DEFAULT NULL COMMENT '收货人姓名',
  `phone` varchar(20) DEFAULT NULL COMMENT '收货人电话',
  `kd_name` varchar(20) DEFAULT NULL,
  `kd_sn` varchar(50) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of erp_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for erp_order_items
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_items`;
CREATE TABLE `erp_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
  `goods_id` varchar(50) DEFAULT NULL COMMENT '商品ID',
  `goods_sn` varchar(50) DEFAULT NULL COMMENT 'SN',
  `goods_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `goods_spec` varchar(32) DEFAULT NULL COMMENT '规格',
  `goods_number` int(11) DEFAULT '1' COMMENT '数量',
  `goods_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品价格',
  `order_id` varchar(50) DEFAULT NULL COMMENT '订单ID',
  `goods_amount` decimal(10,2) DEFAULT '0.00' COMMENT '商品总价',
  `discount` int(11) DEFAULT NULL,
  `shouzi` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of erp_order_items
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
